<%@ page import="java.sql.*, studentportal.*"%>
<html>

<head>
 
<title>New Page 1</title>
</head>
 
<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" align="center" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="10%">
      <a href="Student_Persanal_InfoView.jsp">Personal Info</a></td>
    <td width="10%">
      <a href="Student_Course_InfoView.jsp">Course Info</a></td>
    <td width="10%">
      <a href="Student_Notes_InfoView.jsp">Notes Info</a></td>
    <td width="10%">
      <a href="Student_Assignment_InfoView.jsp">Assignment Info</a></td>

    <td width="10%">
      <a href="Student_Book.jsp">Books</a></td>
    <td width="10%">
      <a href="Student_Notification.jsp">Notifications</a></td>
    <td width="10%">
      <a href="Student_Security_InfoView.jsp">Security</a></td>
    <td width="10%">
      <a href="Home.html">Home</a></td>
  </tr>
</table>
<br><br><br><br>

<%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sr="SELECT book_name, author, edition, from_date, to_date FROM book_borrow where status='A' and from_date is not NULL and to_date is not NULL";
					System.out.println(sr);
					ResultSet rs=st.executeQuery(sr);
%>
</font>
<div align="center">
    <center>
    <table border="1" width="68%" bordercolor="#0000FF">
			<tr>
					<th>Name </th>
					<th>Author</th>
					<th>Edition</th>
					<th>From Date</th>
					<th>To Date</th>
			</tr>
			<%
					while(rs.next())
					{
			%>
						<tr>
								<td><%=rs.getString(1)%></td>
								<td><%=rs.getString(2)%></td>
								<td><%=rs.getString(3)%></td>
								<td><%=rs.getString(4)%></td>
								<td><%=rs.getString(5)%></td>
						</tr>
			<%
					}con.close();
			%>
	</table>
  
</body>
  
</html>
